CREATE TABLE [dbo].[Rpt_WorkingTbl]
(
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_UserID_Date] DEFAULT (''),
[ReceiptID] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ReceiptID] DEFAULT ((0)),
[Org_Code] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_Org_Code] DEFAULT (''),
[Transaction_Date] [datetime] NULL,
[BT_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BT_NAME] DEFAULT (''),
[BT_TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BT_TITLE] DEFAULT (''),
[BT_COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BT_COMPANY] DEFAULT (''),
[BILL_TO] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BILL_TO] DEFAULT (''),
[BT_ID_NAME] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BT_ID_NAME] DEFAULT (''),
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ID] DEFAULT (''),
[MEMBER_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_MEMBER_TYPE] DEFAULT (''),
[LAST_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_LAST_FIRST] DEFAULT (''),
[TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_TITLE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_COMPANY] DEFAULT (''),
[WORK_PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_WORK_PHONE] DEFAULT (''),
[HOME_PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_HOME_PHONE] DEFAULT (''),
[CONTACT_RANK] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CONTACT_RANK] DEFAULT ((0)),
[CHAPTER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CHAPTER] DEFAULT (''),
[CO_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CO_ID] DEFAULT (''),
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_FULL_NAME] DEFAULT (''),
[JOIN_DATE] [datetime] NULL,
[COMPANY_RECORD] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_COMPANY_RECORD] DEFAULT ((0)),
[DESCRIPTION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_DESCRIPTION] DEFAULT (''),
[Temp_Item1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Temp_Item10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PRODUCT_CODE] DEFAULT (''),
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_STATUS] DEFAULT (''),
[BEGIN_DATE] [datetime] NULL,
[PREF_MAIL] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PREF_MAIL] DEFAULT ((0)),
[PREF_BILL] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PREF_BILL] DEFAULT ((0)),
[RENEW_MONTHS] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_RENEW_MONTHS] DEFAULT ((0)),
[SOURCE_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_SOURCE_CODE] DEFAULT (''),
[MAIL_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_MAIL_CODE] DEFAULT (''),
[PREVIOUS_BALANCE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PREVIOUS_BALANCE] DEFAULT ((0)),
[BILL_DATE] [datetime] NULL,
[REMINDER_DATE] [datetime] NULL,
[REMINDER_COUNT] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_REMINDER_COUNT] DEFAULT ((0)),
[BILL_BEGIN] [datetime] NULL,
[BILL_THRU] [datetime] NULL,
[BILL_AMOUNT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BILL_AMOUNT] DEFAULT ((0)),
[PAYMENT_AMOUNT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PAYMENT_AMOUNT] DEFAULT ((0)),
[PAYMENT_DATE] [datetime] NULL,
[BALANCE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BALANCE] DEFAULT ((0)),
[INVOICE_REFERENCE_NUM] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_INVOICE_REFERENCE_NUM] DEFAULT ((0)),
[PTITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PTITLE] DEFAULT (''),
[PROD_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PROD_TYPE] DEFAULT (''),
[PAYMENT_PRIORITY] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PAYMENT_PRIORITY] DEFAULT ((0)),
[CHAPT_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CHAPT_ADDRESS] DEFAULT (''),
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_FULL_ADDRESS] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ADDRESS_2] DEFAULT (''),
[COMPANY_SORT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_COMPANY_SORT] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ZIP] DEFAULT (''),
[COUNTRY_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_COUNTRY_CODE] DEFAULT (''),
[BAR_CODE] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_BAR_CODE] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_COUNTRY] DEFAULT (''),
[PURPOSE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_PURPOSE] DEFAULT (''),
[Temp_Int1] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_Temp_Int1] DEFAULT ((0)),
[Temp_Int2] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_Temp_Int2] DEFAULT ((0)),
[Temp_Int3] [int] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_Temp_Int3] DEFAULT ((0)),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_IS_FR_ITEM] DEFAULT ((0)),
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_ADDRESS_3] DEFAULT (''),
[FAIR_MARKET_VALUE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_FAIR_MARKET_VALUE] DEFAULT ((0)),
[CRRT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_WorkingTbl_CRRT] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iRpt_WorkingTblID] ON [dbo].[Rpt_WorkingTbl] ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_WorkingTblOrg_Code] ON [dbo].[Rpt_WorkingTbl] ([Org_Code]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_WorkingTblReceiptID] ON [dbo].[Rpt_WorkingTbl] ([ReceiptID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_WorkingTblTransaction_Dat] ON [dbo].[Rpt_WorkingTbl] ([Transaction_Date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_WorkingTblUserID_Date] ON [dbo].[Rpt_WorkingTbl] ([UserID_Date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Rpt_WorkingTbl] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_WorkingTbl] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_WorkingTbl] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_WorkingTbl] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_WorkingTbl] TO [IMIS]
GO